home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / oracl / mar97 / koopf101.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  30.0 KB  |  631x169  |  4-bit (16 colors)
   ocr: FIGURE 1: Good clustering Vs. poor clustering. Good clustering can reduce CPU time, clapsed times, disk 1/0, and wasted space, because the order of the rows in the table follows the order of the index entries in the lcaf blocks. Poor clustering makes retrieving data for a given key disorganized, and the associated rows for that koy in the table may be scattered across many noncontiguous blocks, Good Clustering Poor Clustering Root Block (indexi 8-level Bronch Bocks) index) - - -2 - - - Blocks (roblel - - - Leal Blocks indexj - - - - - - : Data